Skip to main content Skip to complementary content

Adding, deleting and renaming mappings

You can add, rename and delete mappings as required. For example, if you want one of the logical entities to contain columns from several tables in the landing zone, then you need to add a new mapping for each of the landing zone tables.

Information note

When mapping "From Date" columns in the Landing Zone to the "FD" Staging column, make sure that the dates in the Landing Zone columns are not earlier than the "Lowest Date" set in the Project Settings. Otherwise, any data with a "From Date" earlier than the "Lowest Date" will be ignored.

If some of the dates in the Landing Zone column are earlier than the "Lowest Date" and cannot be changed in the source, either change the "Lowest Date" set in the Project Settings - or - use a transformation in Replicate to convert the source dates to dates that are within"Lowest Date" to "Highest Date" range defined in your project.

  1. Click the Manage button in the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

  2. In the left pane, select the task you want to add, delete, or rename.
  3. Select the Mappings tab.

Adding a new mapping

  1. In the Logical Entities column, select the logical entity that you want to map.
  2. Click the New button above the Logical Entities column. The New Mapping window opens.

  3. Optionally change the default mapping name.
  4. Click OK to save the mapping.
  5. Enable the mapping.

Deleting a mapping

  1. In the Mappings column, hover the mouse cursor over the mapping you want to delete.
  2. Click the Delete (x) button that appears to its right.
  3. Click OK when prompted to confirm the deletion.

Renaming a mapping

  1. In the Mappings column, hover the mouse cursor over the mapping you want to rename.
  2. Click the Rename (A) button that appears to its right. The Rename window opens.

  3. Specify a new name for the mapping and then click OK.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!